<?

// Connect to the Database - User Connection
include "../ore/uconnect.php";

// Get the Price Data Array---------------------------
$query = mysql_query("SELECT * FROM prices ORDER by id");
	$pDA = array();
	while ($rows = mysql_fetch_assoc($query))
		{	$pDA[$rows['mineral']]=$rows;	}

echo "<pre>";
print_r($pDA);
echo "</pre>";
echo "-----------------------------------------------------------------------";

// Get the Ore Data Array ------------------------------
$query = mysql_query("SELECT * FROM ore order by id");
	$oDA = array();
	while ($rows = mysql_fetch_assoc($query))
		{	$oDA[$rows['sn']]=$rows;	}

echo "<pre>";
print_r($oDA);
echo "</pre>";

//close all connections 
mysql_close($link);

?>